insert into bbp_unit (unit_name,unit_alias,unit_code,unit_level,status,unit_type,province_name,city_name,county_name,address,unit_tel,applicant_id,applicant,apply_date,effect_date) 
values('武汉快付商务服务有限公司', '快付', '999999999999', 0,'EFF', 'U', '湖北省', '武汉市', '汉阳区', '武汉市汉阳区汉阳大道140号闽东国际城3栋B座22层', '4000279228', 101, 'root', sysdate, sysdate);


insert into bbp_organization(id,code,lft,rgt,tp,temp) values(organization_seq.nextval, '999999999999', 1, 2, 'U', '');


insert into bbp_role(id,name,role_type,is_tmp,created_by,created_date) values(100, '系统模版', 'PM','Y','root',sysdate);
insert into bbp_role(id,name,role_type,is_tmp,created_by,created_date) values(101, '管理员', 'PM','N','root',sysdate);
insert into bbp_role(id,name,role_type,is_tmp,created_by,created_date) values(102, '总经理', 'PM','N','root',sysdate);
insert into bbp_role(id,name,role_type,is_tmp,created_by,created_date) values(103, '部门经理', 'PM','N','root',sysdate);
insert into bbp_role(id,name,role_type,is_tmp,created_by,created_date) values(104, '员工', 'PM','N','root',sysdate);

insert into bbp_member(id,unit_code,status,m_type,email,real_name,tel,username) values(100, '999999999999', 'ACT', 'PM','111@123.com', 'root', '12345678901', 'root');


insert into bbp_login_user(id,username,password,email) values(login_user_seq.nextval, 'root', '0937afa17f4dc08f3c0e5dc908158370ce64df86','');

insert into bbp_member_role(member_id,role_id) values(100, 101);




-- (运营管理系统模版)
--系统管理
insert into bbp_role_menu(role_id,menu_id) values(100, 10100);
insert into bbp_role_menu(role_id,menu_id) values(100, 10101);
insert into bbp_role_menu(role_id,menu_id) values(100, 10102);
insert into bbp_role_menu(role_id,menu_id) values(100, 10103);
insert into bbp_role_menu(role_id,menu_id) values(100, 10104);

insert into bbp_role_menu(role_id,menu_id) values(100, 30300);
insert into bbp_role_menu(role_id,menu_id) values(100, 30301);
insert into bbp_role_menu(role_id,menu_id) values(100, 30302);
insert into bbp_role_menu(role_id,menu_id) values(100, 30303);
insert into bbp_role_menu(role_id,menu_id) values(100, 30304);
insert into bbp_role_menu(role_id,menu_id) values(100, 30305);

-- root 用户(管理员)
--系统管理
insert into bbp_role_menu(role_id,menu_id) values(101, 10100);
insert into bbp_role_menu(role_id,menu_id) values(101, 10101);
insert into bbp_role_menu(role_id,menu_id) values(101, 10102);
insert into bbp_role_menu(role_id,menu_id) values(101, 10103);
insert into bbp_role_menu(role_id,menu_id) values(101, 10104);

insert into bbp_role_menu(role_id,menu_id) values(101, 30300);
insert into bbp_role_menu(role_id,menu_id) values(101, 30301);
insert into bbp_role_menu(role_id,menu_id) values(101, 30302);
insert into bbp_role_menu(role_id,menu_id) values(101, 30303);
insert into bbp_role_menu(role_id,menu_id) values(101, 30304);
insert into bbp_role_menu(role_id,menu_id) values(101, 30305);

--总经理
insert into bbp_role_menu(role_id,menu_id) values(102, 30300);
insert into bbp_role_menu(role_id,menu_id) values(102, 30301);
insert into bbp_role_menu(role_id,menu_id) values(102, 30302);
insert into bbp_role_menu(role_id,menu_id) values(102, 30303);
insert into bbp_role_menu(role_id,menu_id) values(102, 30304);
insert into bbp_role_menu(role_id,menu_id) values(102, 30305);

--部门经理
insert into bbp_role_menu(role_id,menu_id) values(103, 30300);
insert into bbp_role_menu(role_id,menu_id) values(103, 30301);
insert into bbp_role_menu(role_id,menu_id) values(103, 30302);
insert into bbp_role_menu(role_id,menu_id) values(103, 30303);
insert into bbp_role_menu(role_id,menu_id) values(103, 30304);
insert into bbp_role_menu(role_id,menu_id) values(103, 30305);

--员工
insert into bbp_role_menu(role_id,menu_id) values(104, 30300);
insert into bbp_role_menu(role_id,menu_id) values(104, 30301);
insert into bbp_role_menu(role_id,menu_id) values(104, 30302);
insert into bbp_role_menu(role_id,menu_id) values(104, 30303);
insert into bbp_role_menu(role_id,menu_id) values(104, 30304);
insert into bbp_role_menu(role_id,menu_id) values(104, 30305);
